﻿/*CREATE TABLE [dbo].[BookOfWorkApplication2013] (
    [PeriodYear]                                INT              NULL,
    [AccountLevel1]                             VARCHAR (25)     NULL,
    [AccountLevel2]                             VARCHAR (25)     NULL,
    [AccountLevel3]                             VARCHAR (25)     NULL,
    [InitiativeId]                              VARCHAR (30)     NULL,
    [InitiativeName]                            VARCHAR (255)    NULL,
    [ProgramId]                                 VARCHAR (30)     NULL,
    [ProgramName]                               VARCHAR (255)    NULL,
    [ProjectId]                                 VARCHAR (10)     NULL,
    [ProjectName]                               VARCHAR (200)    NULL,
    [ProgramManager]                            VARCHAR (255)    NULL,
    [ProgramStartDate]                          DATETIME         NULL,
    [ProgramEndDate]                            DATETIME         NULL,
    [ProjectStatus]                             VARCHAR (100)    NULL,
    [ProjectStartDate]                          DATETIME         NULL,
    [ProjectEndDate]                            DATETIME         NULL,
    [ProjectManager]                            VARCHAR (150)    NULL,
    [ApplicationId	int	(4),
	[ApplicationName] VARCHAR (150)    NULL,
    [BillingClientGocCode]                      VARCHAR (15)     NULL,
    [Client3Name]                               VARCHAR (120)    NULL,
    [Client4Name]                               VARCHAR (120)    NULL,
    [Client5Name]                               VARCHAR (120)    NULL,
    [Client6Name]                               VARCHAR (120)    NULL,
    [Client7Name]                               VARCHAR (120)    NULL,
    [Client8Name]                               VARCHAR (120)    NULL,
    [Client9Name]                               VARCHAR (120)    NULL,
    [Client10Name]                              VARCHAR (120)    NULL,
    [ClientGocCode]                             VARCHAR (15)     NULL,
    [ClientRegion]                              VARCHAR (64)     NULL,
    [System5Name]                               VARCHAR (120)    NULL,
    [System6Name]                               VARCHAR (120)    NULL,
    [System7Name]                               VARCHAR (120)    NULL,
    [System8Name]                               VARCHAR (120)    NULL,
    [System9Name]                               VARCHAR (120)    NULL,
    [System10Name]                              VARCHAR (120)    NULL,
    [SystemGOCCode]                             VARCHAR (15)     NULL,
    [SystemRegion]                              VARCHAR (64)     NULL,
    [LOB]                                       VARCHAR (250)    NULL,
    [RuntheBankBuildtheBank]                    VARCHAR (1)      NULL,
    [ProgramProjectLinkIndicator]               VARCHAR (10)     NULL,
    [WorkTypeFinancials]                        VARCHAR (18)     NULL,
    [InitiativeInvestimentCategory]             VARCHAR (186)    NULL,
    [ProgramInvestimentCategory]                VARCHAR (50)     NULL,
    [ProgramCapitalizedIndicator]               CHAR (1)         NULL,
    [ProgramStatus]                             VARCHAR (50)     NULL,
    [ProjectCapitalization]                     CHAR (1)         NULL,
    [BowFlag]                                   VARCHAR (10)     NULL,
    [BowFlag2]                                  VARCHAR (10)     NULL,
    [ProjectType]                               VARCHAR (100)    NULL,
    [ProgramCarryoverIndicator]                 CHAR (1)         NULL,
    [TaxonomyName]                              VARCHAR (100)    NULL,
    [CURate]                                    DECIMAL (9, 6)   NULL,
    [FirstOfProgramDesc]                        VARCHAR (2000)   NULL,
    [AdjustedFlag]                              VARCHAR (10)     NULL,
    [LobParent]                                 VARCHAR (250)    NULL,
    [January]                                   DECIMAL (38, 18) NULL,
    [February]                                  DECIMAL (38, 18) NULL,
    [March]                                     DECIMAL (38, 18) NULL,
    [April]                                     DECIMAL (38, 18) NULL,
    [May]                                       DECIMAL (38, 18) NULL,
    [June]                                      DECIMAL (38, 18) NULL,
    [July]                                      DECIMAL (38, 18) NULL,
    [August]                                    DECIMAL (38, 18) NULL,
    [September]                                 DECIMAL (38, 18) NULL,
    [October]                                   DECIMAL (38, 18) NULL,
    [November]                                  DECIMAL (38, 18) NULL,
    [December]                                  DECIMAL (38, 18) NULL,
    [YearToDate]                                DECIMAL (38, 18) NULL,
    [FullYear]                                  DECIMAL (38, 18) NULL,
    [ReferenceDate]                             DATE             DEFAULT (getdate()) NOT NULL,
    [LastUpdate]                                DATETIME         DEFAULT (getdate()) NOT NULL
);*/

